RTLS Data Analytics Engineer
Midmark
Traverse City, MI
JOB SUMMARY:
Work closely with an Agile team to build, deploy, and maintain a transformative cloud based data infrastructure that supports an analytics solution. This solution will generate insights from our customers’ data, enabling them to advance the data-driven decision-making capabilities of our Real Time Locating System (RTLS). This role requires understanding of cloud computing services and infrastructure, architecture, data engineering, data analysis, data visualization, and a basic understanding of data science techniques and workflows. Adopts best practices to ensure security, privacy, and compliance for all data assets. Oversees CI/CD processes within the team to ensure sustainable and efficient deployment of code. Develops solutions supporting the movement of data and information assets. Experience with the Azure data platform required. Experience with Tableau or other industry leading BI tool is preferred.
ESSENTIAL/PRIMARY DUTIES:
- Assess existing analytics infrastructure and business processes; advise on and contribute to the design of best-in-class, modern solutions
- Design and develop the analytical layer, building cloud data warehouses, data lakes, ETL/ELT pipelines, and orchestration tools
- Write code in SQL and Python, and use software engineering best-practices such as Git and CI/CD; experience with Spark preferred
- Communicate clearly, effectively, and proactively with local and remote users, teammates and stakeholders
- Install and maintain cloud-based applications, systems, or associated infrastructures in the data and analytics space and support the deployment of analytics solutions across multiple environments
- Foster a culture of sharing, re-use, design for scale stability, and operational efficiency of data and analytical solutions
- Review security assessment recommendations and remediate issues to ensure that appropriate information security standards are met
SECONDARY DUTIES:
- Manage and monitor SLAs for uptime and performance requirements in the Microsoft Azure environment, troubleshooting and resolving errors when they occur
- Document and adhere to all critical processes
- Stay informed of emerging cloud technologies and evaluates the value to the organization's operations
EDUCATION and/or EXPERIENCE:
- Bachelor's degree (B. A.) from four-year college or university in computer science or related engineering field; or equivalent combination of education and experience.
- 5+ years working with relational databases and query languages
- 5+ years building data pipelines in production and the ability to work across structured, semi-structured and unstructured data
- 5+ years data modeling (e.g., star schema, entity-relationship)
- 3+ years writing clean, maintainable and robust code in Python, Scala, Java or similar coding languages is desirable
- Experience working with healthcare data encompassing PHI/PII
- Experience in writing queries across large data sets
- Expertise in Agile software engineering concepts and best practices and/or DevOps is desirable
- Experience working with big data technologies (Spark, Hadoop) is desirable
COMPETENCY/SKILL REQUIREMENTS:
- Exceptional knowledge of data analytics, such as dimensional modeling, ETL\ELT, reporting tools, data governance, data warehousing, structured and unstructured data
- Must have proven success with developing solutions on cloud computing services and infrastructure in the data and analytics space, with focus on Microsoft Azure data platform and DevOps
- Must have experience managing stakeholders and collaborating with customers
- Use of data visualization through BI tool sets, Tableau preferred
- Ability to define and complete work self-directed, under limited supervision
- Ability to work remotely to resolve issues
- Ability to document and follow procedures
- Knowledge and understanding of BI Reporting Tools and Troubleshooting
- Knowledge and understanding of cloud scaling and security practices
SUPERVISORY RESPONSIBILITIES:
- Mentoring of teammates in similar responsibility