Identifies, promotes, and implements best practices for data modeling, using open-source database solutions and using Snowflake, Oracle, and SQL Server technologies. Performs data analysis using Business Intelligence (BI) visualization tools such as Tableau and Power BI. Facilitates the maintenance of data models within Software Development Lifecycle (SDLC) environments -- Agile. Expands or modifies system to serve new purposes or improve workflow. Consults with management to ensure agreement on system principles.Primary Responsibilities:Designs and implements data architecture solutions that support the organization's strategic goals.Works closely with business stakeholders to gather and analyze data and business requirements.Creates reports and dashboards using BI tools such as Tableau, Power BI, and MicroStrategy Dossier. Creates data visualizations to help business stakeholders understand their data.Performs complex data analysis tasks using SQL, Python, and other tools.Develops and maintains data quality rules and processes, identifying, and resolving data quality issues, and monitoring data quality metrics to ensure data accuracy, completeness, and consistency.Collaborates with cross-functional teams.Evaluates new trends and technologies in data analytics, evaluate their potential impact on the organization, and recommend new technologies and processes that can enhance the efficiency and effectiveness of data analytics.Partners with key stakeholders to understand business questions and to design and deliver analytic reports.Collaborates with team members to develop visualization and improve data and analytics usage across the business.Designs, conducts, and evaluates experimental operational models in cases where models cannot be developed from existing data.Performs validation and testing of models to ensure adequacy and reformulating models as necessary.Education and Experience :Bachelors degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience as a Senior IT Data Analyst (or closely related occupation) performing business intelligence data warehousing development using Snowflake and Tableau.Or, alternatively, Masters degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and one (1) year of experience as a Senior IT Data Analyst (or closely related occupation) performing business intelligence data warehousing development using Snowflake and Tableau.Skills and Knowledge :Candidate must also possess:Demonstrated Expertise (DE) performing data conversion for defined benefits data services using Snowflake and Oracle SQL Server; using SQL Server to extract, transform, and load data from various sources to create clean and consistent datasets; using Tableau for data conversion, analysis, and visualization; analyzing data formulas within a defined benefits calculation engine, using SQL; analyzing complex data sets to identify patterns and trends using SQL, Tableau, and Power BI; and creating custom SQL queries to extract and manipulate data.DE designing and developing Business Intelligence (BI) solutions using Tableau and MicroStrategy Dossier; creating dashboards and reports that effectively communicate insights to clients using Tableau and Power BI; leveraging various data sources to create interactive dashboards for users, using Tableau; creating custom visualizations, calculations, and filters that allow users to easily analyze data and make informed decisions, using Tableau and Power BI; creating and managing data connections, building metrics and attributes, and customizing visualizations to meet clients' specific needs, using MicroStrategy Dossier; and delivering high-quality, client-ready reports and dashboards that drive data-driven decision-making using Tableau and Power BI.DE building Dynamic Row-level security (RLS) in Tableau and implementing it on Tableau Server; actively monitoring Tableau dashboards through usage metrics applications and identifying areas of improvement; managing and creating AD groups to efficiently provide access to a large group of individuals; configuring conditional access to Tableau resources through the Admin Portal to ensure secure access to data for authorized users; and using REST APIs for embedded analytics and automation.DE working with business users to create technical documents, project plans, and data models using confluence, SharePoint, and JIRA Align tools; gathering and analyzing requirements from stakeholders and translating them into actionable project plans and technical documentation using SharePoint and JIRA tools; performing unit, functional, and system integration testing; creating test plans, test cases, and test scripts to ensure the quality of deliverables using SharePoint data mapping documents, SQL, and Tableau tools.#PE1M2Certifications: Category: Information Technology Job Description: Position Description :Identifies, promotes, and implements best practices for data modeling, using open-source database solutions and using Snowflake, Oracle, and SQL Server technologies. Performs data analysis using Business Intelligence (BI) visualization tools such as Tableau and Power BI. Facilitates the maintenance of data models within Software Development Lifecycle (SDLC) environments -- Agile. Expands or modifies system to serve new purposes or improve workflow. Consults with management to ensure agreement on system principles.Primary Responsibilities:Designs and implements data architecture solutions that support the organization's strategic goals.Works closely with business stakeholders to gather and analyze data and business requirements.Creates reports and dashboards using BI tools such as Tableau, Power BI, and MicroStrategy Dossier. Creates data visualizations to help business stakeholders understand their data.Performs complex data analysis tasks using SQL, Python, and other tools.Develops and maintains data quality rules and processes, identifying, and resolving data quality issues, and monitoring data quality metrics to ensure data accuracy, completeness, and consistency.Collaborates with cross-functional teams.Evaluates new trends and technologies in data analytics, evaluate their potential impact on the organization, and recommend new technologies and processes that can enhance the efficiency and effectiveness of data analytics.Partners with key stakeholders to understand business questions and to design and deliver analytic reports.Collaborates with team members to develop visualization and improve data and analytics usage across the business.Designs, conducts, and evaluates experimental operational models in cases where models cannot be developed from existing data.Performs validation and testing of models to ensure adequacy and reformulating models as necessary.Education and Experience :Bachelors degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience as a Senior IT Data Analyst (or closely related occupation) performing business intelligence data warehousing development using Snowflake and Tableau.Or, alternatively, Masters degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and one (1) year of experience as a Senior IT Data Analyst (or closely related occupation) performing business intelligence data warehousing development using Snowflake and Tableau.Skills and Knowledge :Candidate must also possess:Demonstrated Expertise (DE) performing data conversion for defined benefits data services using Snowflake and Oracle SQL Server; using SQL Server to extract, transform, and load data from various sources to create clean and consistent datasets; using Tableau for data conversion, analysis, and visualization; analyzing data formulas within a defined benefits calculation engine, using SQL; analyzing complex data sets to identify patterns and trends using SQL, Tableau, and Power BI; and creating custom SQL queries to extract and manipulate data.DE designing and developing Business Intelligence (BI) solutions using Tableau and MicroStrategy Dossier; creating dashboards and reports that effectively communicate insights to clients using Tableau and Power BI; leveraging various data sources to create interactive dashboards for users, using Tableau; creating custom visualizations, calculations, and filters that allow users to easily analyze data and make informed decisions, using Tableau and Power BI; creating and managing data connections, building metrics and attributes, and customizing visualizations to meet clients' specific needs, using MicroStrategy Dossier; and delivering high-quality, client-ready reports and dashboards that drive data-driven decision-making using Tableau and Power BI.DE building Dynamic Row-level security (RLS) in Tableau and implementing it on Tableau Server; actively monitoring Tableau dashboards through usage metrics applications and identifying areas of improvement; managing and creating AD groups to efficiently provide access to a large group of individuals; configuring conditional access to Tableau resources through the Admin Portal to ensure secure access to data for authorized users; and using REST APIs for embedded analytics and automation.DE working with business users to create technical documents, project plans, and data models using confluence, SharePoint, and JIRA Align tools; gathering and analyzing requirements from stakeholders and translating them into actionable project plans and technical documentation using SharePoint and JIRA tools; performing unit, functional, and system integration testing; creating test plans, test cases, and test scripts to ensure the quality of deliverables using SharePoint data mapping documents, SQL, and Tableau tools.#PE1M2Certifications: Category: Information Technology Fidelitys working model blends the best of working offsite with maximizing time together in person to meet associate and business needs. Currently, most hybrid roles require associates to work onsite all business days of one assigned week per four-week period (beginning in September 2024, the requirement will be two full assigned weeks).About Us At Fidelity, we are passionate about making our financial expertise broadly accessible and effective in helping people live the lives they want! We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experiences. For information about working at Fidelity, visit FidelityCareers.com.Fidelity Investments is an equal opportunity employer.Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation please contact the following:For roles based in the US: Contact the HR Leave of Absence/Accommodation Team by sending an email to accommodations@fmr.com, or by calling 800-835-5099, prompt 2, option 2For roles based in Ireland: Contact AccommodationsIreland@fmr.comFor roles based in Germany: Contact A ccommodationsgermany@fmr.com#J-18808-Ljbffrby Jobble

Job Description: Position Description:
Identifies, promotes, and implements best practices for data modeling, using open-source database solutions and using Snowflake, Oracle, and SQL Server technologies. Performs data analysis using Business Intelligence (BI) visualization tools such as Tableau and Power BI. Facilitates the maintenance of data models within Software Development Lifecycle (SDLC) environments -- Agile. Expands or modifies system to serve new purposes or improve workflow. Consults with management to ensure agreement on system principles.
Primary Responsibilities:
<ul><li>Designs and implements data architecture solutions that support the organization's strategic goals. </li><li>Works closely with business stakeholders to gather and analyze data and business requirements. </li><li>Creates reports and dashboards using BI tools such as Tableau, Power BI, and MicroStrategy Dossier. Creates data visualizations to help business stakeholders understand their data. </li><li>Performs complex data analysis tasks using SQL, Python, and other tools.</li><li>Develops and maintains data quality rules and processes, identifying, and resolving data quality issues, and monitoring data quality metrics to ensure data accuracy, completeness, and consistency.</li><li>Collaborates with cross-functional teams.</li><li>Evaluates new trends and technologies in data analytics, evaluate their potential impact on the organization, and recommend new technologies and processes that can enhance the efficiency and effectiveness of data analytics. </li><li>Partners with key stakeholders to understand business questions and to design and deliver analytic reports.</li><li>Collaborates with team members to develop visualization and improve data and analytics usage across the business.</li><li>Designs, conducts, and evaluates experimental operational models in cases where models cannot be developed from existing data.</li><li>Performs validation and testing of models to ensure adequacy and reformulating models as necessary.</li></ul>
Education and Experience:
Bachelor s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience as a Senior IT Data Analyst (or closely related occupation) performing business intelligence data warehousing development using Snowflake and Tableau.
Or, alternatively, Master s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and one (1) year of experience as a Senior IT Data Analyst (or closely related occupation) performing business intelligence data warehousing development using Snowflake and Tableau.
Skills and Knowledge:
Candidate must also possess:
<ul><li>Demonstrated Expertise (\u201CDE\u201D) performing data conversion for defined benefits data services using Snowflake and Oracle SQL Server; using SQL Server to extract, transform, and load data from various sources to create clean and consistent datasets; using Tableau for data conversion, analysis, and visualization; analyzing data formulas within a defined benefits calculation engine, using SQL; analyzing complex data sets to identify patterns and trends using SQL, Tableau, and Power BI; and creating custom SQL queries to extract and manipulate data.</li><li>DE designing and developing Business Intelligence (BI) solutions using Tableau and MicroStrategy Dossier; creating dashboards and reports that effectively communicate insights to clients using Tableau and Power BI; leveraging various data sources to create interactive dashboards for users, using Tableau; creating custom visualizations, calculations, and filters that allow users to easily analyze data and make informed decisions, using Tableau and Power BI; creating and managing data connections, building metrics and attributes, and customizing visualizations to meet clients' specific needs, using MicroStrategy Dossier; and delivering high-quality, client-ready reports and dashboards that drive data-driven decision-making using Tableau and Power BI.</li><li>DE building Dynamic Row-level security (RLS) in Tableau and implementing it on Tableau Server; actively monitoring Tableau dashboards through usage metrics applications and identifying areas of improvement; managing and creating AD groups to efficiently provide access to a large group of individuals; configuring conditional access to Tableau resources through the Admin Portal to ensure secure access to data for authorized users; and using REST APIs for embedded analytics and automation.</li><li>DE working with business users to create technical documents, project plans, and data models using confluence, SharePoint, and JIRA Align tools; gathering and analyzing requirements from stakeholders and translating them into actionable project plans and technical documentation using SharePoint and JIRA tools; performing unit, functional, and system integration testing; creating test plans, test cases, and test scripts to ensure the quality of deliverables using SharePoint data mapping documents, SQL, and Tableau tools.</li></ul>#PE1M2 Certifications: Company Overview Fidelity Investments is a privately held company with a mission to strengthen the financial well-being of our clients. We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients money. Join Us At Fidelity, you ll find endless opportunities to build a meaningful career that positively impacts peoples lives, including yours. You can take advantage of flexible benefits that support you through every stage of your career, empowering you to thrive at work and at home. Honored with a <div class="anchor-hijack" style="display: inline"><a href="\u0022https://www.glassdoor.com/Award/Best-Places-to-Work-LST_KQ0,19.htm\u0022">Glassdoor Employees Choice Award</a></div>, we have been recognized by our employees as a top 10 Best Place to Work in 2024. And you don t need a finance background to succeed at Fidelity\u2014we offer a range of opportunities for learning so you can build the career you ve always imagined. <div class="anchor-hijack" style="display: inline"><a href="\u0022https://jobs.fidelity.com/locations/#dw\u0022">Fidelity's working model</a></div> blends the best of working offsite with maximizing time together in person to meet associate and business needs. Currently, most hybrid roles require associates to work onsite all business days of one assigned week per four-week period (beginning in September 2024, the requirement will be two full assigned weeks). At Fidelity, we value honesty, integrity, and the safety of our associates and customers within a heavily regulated industry. Certain roles may require candidates to go through a preliminary credit check during the screening process. Candidates who are presented with a Fidelity offer will need to go through a background investigation, <div class="anchor-hijack" style="display: inline"><a href="\u0022https://go.fidelity.com/h1vqtc\u0022">detailed in this document</a></div>, and may be asked to provide additional documentation as requested. This investigation includes but is not limited to a criminal, civil litigations and regulatory review, employment, education, and credit review (role dependent). These investigations will account for 7 years or more of history, depending on the role. Where permitted by federal or state law, Fidelity will also conduct a pre-employment drug screen, which will review for the following substances: Amphetamines, THC (marijuana), cocaine, opiates, phencyclidine. We invite you to Find Your Fidelity at <div class="anchor-hijack" style="display: inline"><a href="\u0022https://jobs.fidelity.com/\u0022">fidelitycareers.com</a></div>. Fidelity Investments is an equal opportunity employer. We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging. Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation, contact the HR Accommodation Team by sending an email to <div class="anchor-hijack" style="display: inline"><a href="\u0022mailto:accommodations@fmr.com\u0022">accommodations@fmr.com</a></div>, or by calling <div class="phone-hijack" style="display: inline">800-835-5099</div>, prompt 2, option 3.

Data Modeler 
Fidelity TalentSource is your destination for discovering your next temporary role at Fidelity Investments. We are currently sourcing for a Data Analyst to work in Merrimack, Durham, Westlake, Smithfield, or Jersey City.

 The Role 
We are seeking a highly motivated Data Modeler to join our Data Solutions Center of Excellence. As a skilled analyst, you will provide data analysis leadership on multiple projects simultaneously. You will help conduct data analysis across different projects with diverse scope, sophisticated business and technical requirements in a multi-platform and highly coordinated data environment. This role is analysis and design centric; crafting and detailing data solutions/models, which are then handed to developers, engineers, and DBAs to implement.

 The Expertise and Skills You Bring 

<ul>
	<li>Bachelor’s Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) with a focus on data analysis, data structures, or data modeling.
	</li><li>Expert level analysis skills in the form of research, gap analysis, data mining, and data profiling.
	</li><li>Solid understanding of data lineage. Ability to breakdown and detail the flow of data from origination to consumption.
	</li><li>Proven track record of solving real world problems using a design-oriented modeling approach in large data warehouses, data marts, and analytics/reporting platforms.
	</li><li>Understanding of different database platforms (e.g. Oracle, Snowflake, Hadoop, Microsoft SQL Server) usages (OLTP Recordkeeping, ODS, MDM, Warehousing, and Data Lakes).
	</li><li>Understanding of modeling strategies (dimensional, relational, unstructured).
	</li><li>Robust SQL experience, used to design new platforms on cloud technologies/architecture including Snowflake, AWS, etc.
	</li><li>Proficient with ERD/Data Modeling tools (e.g. SAP Power Designer or Erwin).
	</li><li>Experience carrying out projects in an Agile environment.
	</li><li>Having outstanding interpersonal skills with experience collaborating and influencing across all levels of the organization including written, verbal, and technology illustrations.
	</li><li>Perform autonomously on tasks but are willing and able to share knowledge with coworkers and partners.
	</li><li>Go-getter, self-sufficient, and willing to exhaust all research avenues before seeking help or discontinuing the search for answers.
	</li><li>Accepts uncertainty and can combine various sources of information including personal data experimentation, research, and dialogues to formulate answers.
	</li><li>Values pace over perfection and can show incremental progress of analysis and research through tangible artifacts.
	</li><li>Capable of balancing multiple contending priorities.
	</li><li>Familiar with the financial industry and/or have a strong desire to learn our brokerage business to enhance the value of our data.
	</li><li>Experience with cloud native data warehousing and data lake solutions using Snowflake is a plus.
	</li><li>Experience with Kimball Data Warehouse design techniques.
</li></ul>

 The Team 
We are responsible for designing and delivering data mapping specifications and data models for large reporting and analytics platforms. Our mappings detail all data movement and transformation, detailing business rules using a combination of SQL and pseudocode. Our data models (DDLs and model reports) are generated via SAP Power-Designer and define all database objects.

 COVID Work Policy 
Safety is our top priority. Once we can be together in person with fewer safety measures, this role will follow our dynamic working approach. You’ll be spending some of your time onsite depending on the nature and needs of your role.

 Dynamic Working – Post Pandemic 
Our aim is to combine the best of working offsite with coming together in person. For most teams this means a consistent balance of working from home and office that supports the needs of your role, experience level, and working style. 
Your success and growth is important to us, so you’ll want to enjoy the benefits of coming together in person – face to face learning and training, quality time with your manager and teammates, building your career network, making friends, and taking full advantage of cultural and social experiences Fidelity provides for you. 

 Company Overview 

Fidelity TalentSource is the in-house temporary staffing provider for Fidelity Investments, one of the largest and most diversified global financial services firms in the industry. We welcome individuals from all backgrounds, including technology and customer service, to fill assignments across Fidelity’s U.S.-based regional and investor center locations. If you would like to experience Fidelity’s supportive and collaborative culture while expanding your skill set and developing your professional network, consider a role with Fidelity TalentSource. Apply today at <div class="anchor-hijack" style="display: inline"><a href="https://www.fidelitytalentsource.com/">FTSJobs.com</a></div>.
We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.
 
Fidelity TalentSource will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation, please contact our HR team at <div class="anchor-hijack" style="display: inline"><a href="mailto:HR@ftsjobs.com">HR@ ftsjobs.com</a></div>.
 Information about Fidelity Investments 

At Fidelity Investments, our customers are at the heart of everything we do. As a privately held company with a rich 75-year history, our mission has remained the same since our founding: to strengthen the financial well-being of our clients. We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients’ money. For information about working at Fidelity, visit <div class="anchor-hijack" style="display: inline"><a href="FidelityCareers.com">FidelityCareers.com</a></div>.
Fidelity Investments and Fidelity TalentSource are equal opportunity employers.

Data Analyst Jobs in Merrimack, NH

Senior It Data Analyst
April 24, 2024

Senior It Data Analyst
April 22, 2024

Senior It Data Analyst
April 21, 2024

Senior It Data Analyst
April 17, 2024

Data Analyst Modeler
April 9, 2024

Principal It Data Analyst
April 4, 2024

Quick filters

Top companies

Data Analyst Jobs in Merrimack, NH

Senior It Data AnalystApril 24, 2024

Senior It Data AnalystApril 22, 2024

Senior It Data AnalystApril 21, 2024

Senior It Data AnalystApril 17, 2024

Data Analyst ModelerApril 9, 2024

Principal It Data AnalystApril 4, 2024