Senior Business System Analyst

As a Business Systems Analyst, you will be responsible for providing expert content and professional leadership on complex assignments and projects. You will contribute to data oversight, data usage, system analysis, and data retention to assure data quality standards. Collaborating with other departments, you will ensure data consistency and quality throughout the organization. This role requires considerable creativity, foresight, and judgment in conceiving, planning, and delivering initiatives. You will use your deep professional knowledge and acumen to advise functional leaders. This position is specifically put in place to complete the migration of usage across legacy systems (predominantly MS SQL Server but other RDBMS may be involved) to the Lakehouse (Azure Databricks). You will work with other analysts and development teams comprised of onshore and offshore developers, exploring data processes and usage of systems to determine next steps for migration and foster adoption from users to our modern platforms. This will require heavy analysis of usage against the legacy system as well as platforms within our Azure environment. You will interact with business stakeholders and SMEs. Healthcare data knowledge is a major plus. This is a very fast-paced environment that will require a lot of self-guidance and motivation. Minimum Qualifications:

• In-depth knowledge in SQL, MS SQL Server stack (SSIS, SSRS, Information Schema), Azure Databricks, Azure Data Factory, Azure Storage Services, Python, SparkSQL, DevOps & GIT
• Fluent understanding of data models, schemas, and databases to support analytical and reporting needs, and use SQL for data manipulation and querying
• Advanced proficiency in data processing
• Advanced capabilities with data profiling, validation, and analytics
• Advanced analytics skillsets with MS Excel, making use of Excel's data retrieval capabilities, pivot tables, data comparison operations, etc.
• Strong ability to explore, discover, and map out large data pipelines that support the processing of structured and semi-structured data
• Working knowledge of CICD pipelines for Azure resources
• Highly organized and able to track multiple fast-moving projects at a time
• Knowledge and experience in an enterprise-level data warehouse environment with knowledge of data architecture patterns and best practices
• In-depth knowledge of the US Healthcare industry to address healthcare-related challenges through data engineering solutions with particular emphasis in medical claims data
• Excellent written and verbal communication skills, with the ability to effectively convey complex analytical findings and tell a compelling story with data
• Ability to work in a client-facing project environment independently

Responsibilities:

• Provide expert content and professional leadership on complex Data Management Strategy & Governance assignments/projects
• Contribute to data oversight, data usage, system analysis, and data retention to assure data quality standards
• Collaborate with other departments to ensure data consistency and quality throughout the organization
• Exercise considerable creativity, foresight, and judgment in conceiving, planning, and delivering initiatives
• Use deep professional knowledge and acumen to advise functional leaders

What’s In It For You:

• Weekly Paychecks
• Medical, Dental & Vision Benefits

Education:

• Bachelor’s degree preferred but not required
• 3-5+ years of experience in an enterprise data warehousing environment with similar duties as described above, preferably using both MS SQL Server and Azure data platforms
• HS Diploma or GED is minimum requirement

Apply Job! Apply to this Job