acquires, cleans and develops datasets from internal and external sources to support business analysis and reporting
acquire, validate, store, protect, and adhere to processes around data to ensure the accessibility, reliability, and timeliness of the data for its users
responsible for developing and executing data architectures, policies, practices and procedures that properly manage the full data lifecycle needs of an enterprise
interact with business and IT departments in understanding user needs
translate business needs to technical requirements in terms of data needs
maintain confidentiality and work independently
identifies opportunities for process improvements
coordinates with other teams to ensure all aspects of data needs are taken into account
coordination and completion of projects on time and within scope
prepare data for reporting and analysis including visualizations to support business requirements
perform in-depth data analysis to derive insights that drives business outcomes and decisions

Requirements

Bachelor’s degree
Minimum 7 years of technical experience in data analysis using ETL tools and developing ETL solutions using SSIS, ADF, and/or DataBricks
Experience working in a SQL environment with comprehensive knowledge of SSMS and SSIS
Extensive experience developing stored procedures and dynamic SQL
Strong working knowledge of Cloud Technologies (For example Azure Synapse Analytics, Snowflake and/or related cloud technology) and Power Platforms (Power BI, Power Automate, & Power Apps)
Experience taking complex data and making it more accessible, understandable and usable for leaders to derive insights
Experiencing leading projects through entire life cycle, from design, coding, code review and deployment
Proficient in root cause analysis
Demonstrated ability to problem solve and provide solutions for business or data issues
Good presentation skills to conduct demonstration meetings with clients to show progress on projects
Experience working with deadlines and skills in addressing customer satisfaction

Benefits

medical, dental and vision benefits
401(k) retirement savings plan
time off (including paid time off, company and personal holidays, volunteer time off, paid parental and caregiver leave)
short-term and long-term disability
life insurance

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data analysisETL toolsSSISADFDataBricksSQLstored proceduresdynamic SQLCloud TechnologiesPower BI

Soft Skills

problem solvingpresentation skillsindependenceprocess improvementcoordinationcommunicationproject managementuser needs understandingdata accessibilitycustomer satisfaction

Certifications

Bachelor's degree