Analytics Developer 3

Job Summary

The Digital & Marketing Analytics team provides advanced analytics products/dashboards and reporting services to stakeholders in the Digital and Marketing teams.

As a member of the Customer Analytics team, you will play a significant role in elevating how individuals experience our digital assets and marketing initiatives. Your responsibilities will play an active role in advancing the state of analytics for all BSWH digital assets and marketing. The Analytics Developer will partner with multiple teams on the identification and creation of key metrics and targets for tracking and reporting in PBI dashboards; providing analyses and data products that yield valuable insights to our stakeholders. You will perform requirements definition, development, testing, research, and ad-hoc reporting as requested.

Essential Functions of the Role

• Gather and document data requirements from customers. Analyze and translate requirements into technical specifications, process and work flows. May serve in a lead consultant role for all customer contact and resource management.
• Analyze business requirements and source systems to design and develop solutions using a variety of toolsets. Develop the deliverables requested utilizing the most appropriate analytic tools while incorporating process efficiencies.
• Extract, transform and load data into database as required utilizing the most appropriate tool.
• Assess, produce and/or develop complex relevant, standard, or custom information (reports, dashboards, interactive reporting, charts, graphs and tables) from various data sources by querying data and generating the associated output. Distribute and disseminate analytical deliverables to applicable agencies, researchers, management and other customers.
• Lead validation of output and metrics to ensure data quality, reliability and integrity.
• Document project/work assignments to include all needed technical documentation such as source to target mappings, data sources, definitions, methodologies, contact information, output requirements or other information to ensure continuity of process.
• Interpret complex data and associated deliverables (reports, dashboards, interactive reporting, charts, graphs and tables) in plain business language for executive & clinical staff. Effectively summarize information and create intuitive/digestible information by selecting visualizations that are fit for purpose.
• Develop statistical, economic and financial analysis from data to evaluate performance and drive relevant business or clinical initiatives. Analyze data for trends, observations, improvements and makes recommendations.
• Provide training and mentoring to junior colleagues.

Key Success Factors

• Advanced data manipulation, troubleshooting and analytical skills.
• Advanced development skills in the use of enterprise analytical and Bl tools, such as Cognos, Tableau, QIickView, Excel PowerPivot or SSRS.
• Advanced skill in the use of programming languages such as SAS, SQL, R, or ST ATA. 
  Verbal and written communication skills.
• Ability to design, develop and implement systems necessary to collect, maintain, and analyze 
  data.
• Ability to gather and analyze data, statistical data and develop reports.
• Ability to work independently and lead cross-functional teams with minimal supervision. 
• Knowledge of ETL & Data Warehousing.
• Ability to work with complex data of varying levels of quality and validity.
• Ability to develop data analytics and BI applications in a clear and understandable manner 
  meeting user requirements.
• Ability to learn new processes and to find opportunities to gain efficiencies in current 
  Environment.

Preferred Qualifications: 

Proficiency with:

• SQL
• Snowflake
• PowerBI

Experience with:

• web analytics tools
• prior experience in a regulated industry (finance, healthcare, etc.)
• Web or mobile app development
• Microsoft Dynamics
• Amplitude
• Operating in Agile environment
• AI tools, such as GitHub Copilot, Snowflake Cortex
• Agentic framework and desire to create Agents and skills etc.

Minimum Qualifications

• Bachelor's (preferably in Statistics, Operations Research, Physics, Computer Science, 
  Economics, Business, Clinical) or 4 years of work experience above the minimum qualification
• 5 Years of Experience