Job Description
Position Description :
Writes queries and pulls data from relational databases using SQL using Agile methodologies and practices Jira / Jira Align.
Gathers business requirements and translates them into data solutions. Defines use cases and simplifies complex concepts relating to data management.
Defines user stories and breaks up complex work into digestible work elements. Performs data analysis and participates in projects with diverse scope, including complex business and technical requirements in a multi-platform and highly integrated data environment.
Defines and communicates sophisticated concepts of data analysis to technical and non-technical audiences. Navigates integrated enterprise data by working across multi-functional teams.
Primary Responsibilities :
Works on various data lakes on platforms.
Collaborates to enable data driven decision making across the Fidelity Institution.
Analyzes science, engineering, business, and other data processing problems to develop and implement solutions to complex applications problems, system administration issues, or network concerns.
Performs systems management and integration functions.
Improves existing computer systems.
Reviews computer system capabilities, workflow, and schedule limitations.
Analyzes or recommends commercially available software.
Expands or modifies system to serve new purposes or improve workflow.
Consults with management to ensure agreement on system principles.
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) gathering business requirements, developing SQL scripts to extract complex data sets, and identifying, analyzing, and interpreting trends to inform key business decisions.
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) gathering business requirements, developing SQL scripts to extract complex data sets, and identifying, analyzing, and interpreting trends to inform key business decisions.
Skills and Knowledge :
Candidate must also possess :
Demonstrated Expertise ( DE ) analyzing and prioritizing business and functional requirements using Microsoft Word, Microsoft Excel (MS Excel), Power Point, and MySQL;
and liaising with business partners to gather user requirements, and analyzing the scope, impact, and dependencies translating them to data solutions, ultimately landing in Amazon Redshift and Excel.
DE performing Extract Transform Load (ETL) on Cloud native data warehousing solutions using analytical tools (Alteryx) and programming languages (Python);
building and maintaining data pipelines utilizing Python, CronTab, Linux server, and Jupyter Notebook; and creating scalable visual analytics dashboards using Tableau and Looker.
DE developing SQL scripts to extract large complex datasets and applying data quality checks to improve data quality, consistency, and integrity using PostgreSQL and PL / SQL;
and performing advanced calculations on metrics, investigating key business trends, and providing actionable insights to support business growth and decisions using Alteryx and MS Excel.
DE building and automating ad-hoc and recurring daily, weekly, and monthly reports to provide data-driven insights to stakeholders sales and digital marketing teams, using MS Excel, Alteryx, Tableau and Python;
and conducting performance analysis on marketing and promotional campaigns to effectively measure the return on investment based on key indicators using Google Analytics, Facebook analytics, Spotify Analytics, and YouTube Analytics.
PE1M2
Certifications :
Senior Data Engineer
Are you a seasoned Data Engineer with expertise in ETL processes, database design, and performance tuning? We are seeking a Senior Data Engineer to join our clients team in Irving, TX, in a hybrid capacity. Partner with Data Science, Analytics, and Product teams to understand and address their data ...
Senior IT Data Analyst
DE developing SQL scripts to extract large complex datasets and applying data quality checks to improve data quality, consistency, and integrity using PostgreSQL and PL/SQL; and performing advanced calculations on metrics, investigating key business trends, and providing actionable insights to suppo...
Senior Data Financial Management Analyst
Collaborate with cross-functional teams to gather data requirements, understand data needs, and ensure alignment with organizational objectives to develop and publish reports internally to executive management and to the public. Use of the permitting data in relation to performance metrics for turna...
Senior Healthcare Data Analyst - REMOTE
The Senior Healthcare Data Analyst provides data analysis support to the customer by assisting with the development of reports and/or dashboards to monitor program and operational performance. The Healthcare Data Analyst Senior provides data analysis support to the customer by assisting with the dev...
Senior Data Scientist, IT Engineering & Operations (Generation/Wholesale)
It is the policy of the Company to comply with all employment laws and to afford equal employment opportunity to individuals in all aspects of employment, including in selection for job opportunities, without regard to race, color, religion, sex, sexual orientation, gender identity, pregnancy, natio...
Senior Data Analyst - Level 3
Manage the quality assurance of data scraping, query databases for stakeholder requests, and triage data issues for timely resolutions. Experience collecting and compiling datasets from disparate data sources into the required data structure. Strong analytical skills and understanding of system data...
Senior Analyst, Data Intelligence
Our employment decisions are made without regard to actual or perceived race, color, ethnicity, religion, creed, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, childbirth and related medical conditions, national origin, ancestry, citizenship status, age, disability, ...
Data Analyst Senior (Level 3)
The candidate will operate in a virtual and dynamic environment with cross-functional teams where he/she will have to manage competing priorities to help deliver solutions to complex data problems. You will be working alongside Data Scientists and Quality professionals to design and deliver the most...
Senior Data Analyst
Collect, interpret, and aggregate data from traditional and non-traditional data sources for supporting programs and applications utilizing various data analytics purposes. Support the design, development, testing, and deployment of data analytics programs and processes for supporting various operat...
Senior IT Analyst
Experience working with large datasets (preferably loading big data to a database). Diversity, inclusion, and belonging is a guiding principle of the organization to ensure its workforce reflects the communities it serves. Diversity, inclusion, and belonging is a guiding principle of the organizatio...