MS BI / A&M Developer / ETL Engineer
Phoenix, AZ, US, 85006
International SOS
International SOS: Pioneer & Leader in International Health & Security Risk Management. Protecting people from health & security threats.Overall Purpose Of The Job
This is a Microsoft Business Intelligence Software Engineer role largely responsible for providing data analytics insights to the organization.
Key Responsibilities
- Gather business requirements from Clients or Business Analysts
- Design & Develop data warehouse solutions based on requirements
- Maintain a high standard of delivery quality
- Innovate and look for new solutions/components
- Build POCs to demonstrate new usage and present them to a senior audience
- Elaborate project documentation (Design documents, deployment guide, …)
- Maintenance of existing BI projects, reports, dashboards, and ETL processes
- Build strong relationships with stakeholders to understand business challenges and opportunities.
- Identify issues, gather information from various sources, and translate essential business needs into technical specifications that are used as reference for data product design.
- Automate processes
- Deliver improvements to Data Warehouse, data marts, reports, dashboards
- Spearhead detailed data analysis and modeling
Required Skills and Knowledge
- 4+ Years of Experience in Microsoft Business Intelligence (MSBI), SSIS, Ab Initio or other ETL tools
Technical
- Expertise in Microsoft SQL Server
- Expertise in writing complex SQL queries and performance optimization
- Expertise in Data Warehouses design, data modeling, and semantic layer definition
- Expertise in SSIS building and optimizing
- Expertise in SSAS
- Expertise using PowerBI and SSRS
- Experience in writing MDX queries, DAX queries
- Experience of using Visual Studio TFS
- Possess superior organization skills to be able to manage end-to-end data product development with production development, conducting system integration/user acceptance testing, etc
- Be a steward of good data practices - robust documentation (i.e.: metadata), versioning, play booking, processes, and knowledge sharing.
- Ability to work with the team to support the maintenance of data platforms
Nice to have
- Exposure to other data visualization tools (Tableau, Qlik)
- Exposure to data analytics, and data science (Python, Spark, etc.)
- Exposure to Cloud Architecture (AWS/Azure)
- Exposure to development on .Net (4.5 to 4.8)
- Exposure to Data virtualization
Innovation:
- Develop a good working knowledge of available technology capabilities and how and where to deploy them.
- Evaluate potential technical solutions and make recommendations to resolve business problems.
Required Competencies
- Proactive style of working
- Strong communication (written, and verbal) and organizational skills
- Strong desire to keep abreast of emerging technologies
- Team player mindset
- Understanding and respect of cultural diversity
Required Work Experience
- 4+ years’ experience in Microsoft Business Intelligence (MSBI)
Required Qualifications
- Computer Science/Engineering or a related discipline
Required Languages
- Excellent written and spoken English
Travel / Rotation Requirements
- N/A
International SOS is an equal opportunity employer and does not discriminate against employees or job applicants on the basis of race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture AWS Azure Business Intelligence Computer Science Data analysis Data Analytics Data visualization Data warehouse Engineering ETL Power BI Python Qlik Spark SQL SSIS Tableau Testing
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open Marketing Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Principal Data Engineer jobs
- Open MLOps Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Data Analytics Engineer jobs
- Open Business Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Analyst Intern jobs
- Open Product Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Research Scientist jobs
- Open Big Data Engineer jobs
- Open Azure Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Data Quality Analyst jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs