Data Analyst/Engineer – Data Modeling & Analytics
Full Time • Hybrid - US
We seek a Senior Data Analyst/Engineer with expertise in data modeling, analytics, and ETL processes to join our team. The ideal candidate will have significant experience with data modeling for analytic services, working with tabular and multidimensional models, and troubleshooting complex data warehouse and reporting system issues. This role requires a deep understanding of cloud-based data analytics services, particularly within the Microsoft Azure ecosystem, and a strong background in data integration, reporting, and optimizing data workflows.
Key Responsibilities:
- Design, develop, and manage tabular and multidimensional data models for analytic services, ensuring optimal performance and scalability.
- Troubleshoot and analyze data warehouse and report system issues, identify root causes, and implement effective solutions.
- Write complex SQL queries to extract and manage large datasets, ensuring efficient data retrieval.
- Using tools like Power BI or Tableau, develop interactive visual reports and dashboards with filters, variables, and drill-down capabilities.
- Design and manage ETL processes, ensuring seamless data integration from on-premises and cloud-based sources.
- Schedule and automate ongoing data processing jobs to ensure reliable data pipelines.
- Optimize data processing workflows for improved performance and reliability.
- Ensure data security through role-based access control (RBAC), encryption, and industry standards (e.g., HIPAA) compliance.
- Collaborate with cross-functional teams to design scalable data solutions that meet growing data volumes and user demands.
- Document technical processes, data models, and system configurations for development and operational purposes.
- Implement high availability and disaster recovery processes to ensure business continuity.
- Optimize resource usage and cost efficiency in cloud-based data solutions.
- Stay up-to-date with emerging technologies and best practices in data engineering and analytics.
Qualifications:
- Extensive experience with data warehouse modeling and development, including experience with both tabular and multidimensional models.
- Strong understanding of Microsoft Azure services, particularly Azure Data Warehouse (DW), Azure Data Factory, and other Azure analytics services.
- Experience writing complex queries in SQL Server and Oracle to manage large-scale datasets.
- Hands-on experience with Power BI, SSRS, Tableau, and similar visualization tools for creating interactive reports and dashboards.
- Familiarity with Python or other scripting languages for data manipulation and automation.
- Strong understanding of data security measures, including encryption and role-based access control (RBAC).
- Knowledge of industry data compliance regulations, such as HIPAA.
- Ability to design scalable data solutions that handle large data volumes and user demand.
- Experience with process optimization, including improving data models' and ETL workflows' performance and reliability.
- Good understanding of high availability and disaster recovery concepts.
- Experience with issue tracking and project management tools like Jira and familiarity with Agile software development methodologies.
- Strong communication skills and ability to work collaboratively across teams.
- Ability to maintain and create technical documentation for both development and operational purposes.
Desired Skills:
- Experience with machine learning techniques and their integration into data analytics workflows.
- Certifications in relevant technologies (e.g., Microsoft Solutions Developer, Oracle, Google Cloud, etc.) that demonstrate expertise in data analytics and cloud technologies.
- Experience with ERWIN or similar data modeling tools for database design and structure.
Salary Range: $120,000 - $160,000 per year
Flexible work from home options available.
Compensation: $120,000.00 - $160,000.00 per year
Crafting Transformative Journeys, Celebrating Individuality, and Making Lasting Impact.
Our ultimate aspiration centers around the essence of people. We aim for individuals to recognize that our purpose is rooted in service, and our streamlined delivery process guarantees the swiftest route to their satisfaction. Service isn’t just a part of what we do; it’s our ethos.
Choosing accel bi isn’t merely opting for a service provider; it’s embarking on a transformative journey where you nurture expertise, apply knowledge, and undergo personal reinvention through dynamic engagement with diverse challenges. Our work environment pulsates with dynamism, presenting a plethora of opportunities for both professional growth and advancement. What sets us apart is our unwavering commitment to ethical business conduct.
At accel bi, decisions are grounded in a commitment to benefit our people, customers, and communities. This commitment makes us the ideal choice for those in search of a professional experience that is not only fulfilling but also leaves a lasting impact.
We pride ourselves on selecting the very best people, irrespective of their capabilities, and in fact, we actively support hiring individuals with disabilities. This inclusive approach reflects our belief in the diverse strengths that contribute to our collective success.
Welcome to a workplace that values you not just as an employee but as an individual on a remarkable journey.
(if you already have a resume on Indeed)