Senior SQL BI Developer ETL
Senior SQL BI Developer ETL
Posted on :
05-04-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Simeio is a global identity and access management service provider focused on protecting organizations key data and access requirements to businesscritical systems and applications.
Simeio provides services such as Access Management IGA PAM & CIAM plus our wider service offerings include support upgrades governance and application onboarding.
The Opportunity:
Skilled SQL BI Developer responsible for designing developing and maintaining ETL processes to support our data integration and data warehousing needs. Will work closely with data analysts data scientists and other stakeholders to ensure data is accurately and efficiently processed and available for analysis.
The Role:
Design and Architecture:
Design develop and maintain ETL processes using SQL and ETL tools.
Extract transform and load data from various data sources into data warehouses and data marts.
Implement data validation and error handling mechanisms.
Design develop and maintain SQL databases and queries.
Write and optimize complex SQL queries for data extraction and reporting.
Automate SSIS packages using SQL Agent.
Hands on experience with windows scheduler and bat file processing
Develop stored procedures functions and triggers to support application development.
Performance Monitoring and Optimization:
Optimize and tune ETL processes for performance and scalability.
Monitor and troubleshoot database issues to ensure high availability and performance.
Monitor and troubleshoot ETL processes to ensure data accuracy and integrity.
Stakeholder Collaboration:
Collaborate with data analysts and data scientists to understand data requirements and ensure data quality.
Best Practices and Standard
Develop and maintain documentation for ETL processes and data flows.
Participate in code reviews and provide feedback to ensure best practices are followed.
Stay up to date with industry trends and best practices in ETL and data integration.
Preferred Skills:
Proven experience as an SQL ETL Developer or similar role.
Strong proficiency in SQL and experience with ETL tools (e.g. SSIS Informatica Talend).
Experience with data warehousing concepts and technologies.
Knowledge of database management systems (e.g. SQL Server Oracle MySQL).
Familiarity with data visualization tools (e.g. Tableau Power BI).
Knowledge of scripting languages (e.g. Python Shell scripting C#.
Strong problemsolving and analytical skills.
Excellent communication and collaboration skills.
Ability to work independently and as part of a team.
About Simeio:
Simeio has over 650 talented employees across the globe. We have offices in USA (Atlanta HQ and Texas) India Canada Costa Rica and UK.
Founded in 2007 and now backed by private equity company ZMC Simeio is recognized as a top IAM provider by industry analysts.
Alongside Simeios identity orchestration tool Simeio IO Simeio also partners with industry leading IAM software vendors to provide access management identity governance and administration privileged access management and risk intelligence services across onpremise cloud and hybrid technology environments.
Simeio provides services to numerous Fortune 1000 companies across all industries including financial services technology healthcare media retail public sector utilities and education.
Simeio is an equal opportunity employer. If you require assistance with completing this application interviewing completing any preemployment testing or otherwise participating in the employee selection process please direct your inquiries to our recruitment team emailprotected.
Thank you
About your application:
We review every application received and will get in touch if your skills and experience match what were looking for. If you dont hear back from us within 10 days please dont be too disappointed we may keep your CV on our database for any future vacancies and we would encourage you to keep an eye on our career opportunities as there may be other suitable roles.
Simeio provides services such as Access Management IGA PAM & CIAM plus our wider service offerings include support upgrades governance and application onboarding.
The Opportunity:
Skilled SQL BI Developer responsible for designing developing and maintaining ETL processes to support our data integration and data warehousing needs. Will work closely with data analysts data scientists and other stakeholders to ensure data is accurately and efficiently processed and available for analysis.
The Role:
Design and Architecture:
Design develop and maintain ETL processes using SQL and ETL tools.
Extract transform and load data from various data sources into data warehouses and data marts.
Implement data validation and error handling mechanisms.
Design develop and maintain SQL databases and queries.
Write and optimize complex SQL queries for data extraction and reporting.
Automate SSIS packages using SQL Agent.
Hands on experience with windows scheduler and bat file processing
Develop stored procedures functions and triggers to support application development.
Performance Monitoring and Optimization:
Optimize and tune ETL processes for performance and scalability.
Monitor and troubleshoot database issues to ensure high availability and performance.
Monitor and troubleshoot ETL processes to ensure data accuracy and integrity.
Stakeholder Collaboration:
Collaborate with data analysts and data scientists to understand data requirements and ensure data quality.
Best Practices and Standard
Develop and maintain documentation for ETL processes and data flows.
Participate in code reviews and provide feedback to ensure best practices are followed.
Stay up to date with industry trends and best practices in ETL and data integration.
Preferred Skills:
Proven experience as an SQL ETL Developer or similar role.
Strong proficiency in SQL and experience with ETL tools (e.g. SSIS Informatica Talend).
Experience with data warehousing concepts and technologies.
Knowledge of database management systems (e.g. SQL Server Oracle MySQL).
Familiarity with data visualization tools (e.g. Tableau Power BI).
Knowledge of scripting languages (e.g. Python Shell scripting C#.
Strong problemsolving and analytical skills.
Excellent communication and collaboration skills.
Ability to work independently and as part of a team.
About Simeio:
Simeio has over 650 talented employees across the globe. We have offices in USA (Atlanta HQ and Texas) India Canada Costa Rica and UK.
Founded in 2007 and now backed by private equity company ZMC Simeio is recognized as a top IAM provider by industry analysts.
Alongside Simeios identity orchestration tool Simeio IO Simeio also partners with industry leading IAM software vendors to provide access management identity governance and administration privileged access management and risk intelligence services across onpremise cloud and hybrid technology environments.
Simeio provides services to numerous Fortune 1000 companies across all industries including financial services technology healthcare media retail public sector utilities and education.
Simeio is an equal opportunity employer. If you require assistance with completing this application interviewing completing any preemployment testing or otherwise participating in the employee selection process please direct your inquiries to our recruitment team emailprotected.
Thank you
About your application:
We review every application received and will get in touch if your skills and experience match what were looking for. If you dont hear back from us within 10 days please dont be too disappointed we may keep your CV on our database for any future vacancies and we would encourage you to keep an eye on our career opportunities as there may be other suitable roles.
Simeio is an equal opportunity employer. If you require assistance with completing this application interviewing completing any preemployment testing or otherwise participating in the employee selection process please direct your inquiries to any of the recruitment team at or.
Required Experience:
Senior IC
Employment Type
Full-Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
