Data Engineer (SQL Server, Power BI, SSIS, SSRS)
United States
Nexient
Nexient is America’s largest 100% US-based software development consulting firm. We help clients outpace their competition through agile development, digital innovation and product-minded / project to product strategies.Role and Responsibilities:
- This data engineer should have exceptional SQL Server programming skills as follows
- Needs to have advanced Business Intelligence experience
- BIML scripting
- SSIS, SSRS, SSAS
- Power BI
- Excellent Leadership and communication skills
- Optional - .Net Application development
- Optional - Web (Angular) application development
- Should be able to mentor other developers in terms of processes and practices
- Should be able to troubleshoot and remediate performance issues
- Should have good data modelling concepts
- Extensive experience with reporting using Power BI
- Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
- Design and develop ETL Processes that will transform a variety of raw data, flat files, xl spreadsheets into SQL Databases
- In-depth knowledge of standard concepts, practices and procedures related to database management
- Experience coding complex stored procedures (using T-SQL)
- Experience with developing SSIS packages
- Proven analytical problem solving and debugging skills
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.
- Providing database support for development and deployment of database scripts in Development, Test, Pre-Production and Production environments
- Design and develop enterprise and departmental business intelligence and data warehousing solutions
- Performs ad-hoc analysis using T-SQL query language within the database systems using a process-oriented approach
- Understands the concept of Data marts and Data lakes and experience with migrating legacy systems to data marts/lake
- Uses additional cloud technologies (e.g. understands concept of Cloud services like Azure SQL server)
- Uses SQL Server Analysis Services to enhance existing, or develop new, OLAP cubes used in the EDW system
- Uses Multi-Dimensional Expression (MDX) query language to extract data from OLAP cubes for reporting and analytical purposes
Why Nexient As a vital member of our Engineering Practice, you will be part of one of our 100+ small cross-functional teams working side by side with some of the most talented developers, UX designers, analysts, quality engineers, and product managers out there. From Silicon Valley to Ann Arbor, Columbus, and beyond – a career with Nexient will offer you: Remote, hybrid, or onsite opportunities: Here, you decide the work arrangement that best suits your needs and preferences. Fulfilling and challenging projects: You will be exposed to different scenarios, multiple types of clients, and the most complex business and technology initiatives. Access to the most cutting-edge technologies: You’re always going to be advancing your skillset by learning and working with the newest and most relevant technologies available out there. A positive and passionate culture: Boring and divided aren’t in our vocabulary. In fact, it’s amazing to see how, despite our exponential growth, the Nexient culture and community stay as warm, diverse, and close as ever. Plenty of opportunities for you to explore and grow: We will empower you to dream as big as you want and support you to make your career what YOU want it to be. Creative runway: We take pride in encouraging our people to question the status quo. Our benefits program includes: · Medical, dental, and vision coverage· Generous PTO, plus holidays· 401(k) plan· Life insurance and short-term & long-term disability· Maternity leave· Employee Assistance Program· Flexible spending accounts· Health savings account Nexient is an inclusive, equal opportunity employer. At Nexient, your uniqueness makes us better. Your uniqueness is why you are valued, you are heard, you add to our culture, and you belong. Diversity & Inclusion is hardcoded into our DNA and at the core of everything we do. Together, not separately, we strive to become even more diverse to help fuel our innovation and connect us closer with the clients and communities we serve.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile ANN Azure Business Intelligence Data Warehousing Engineering ETL OLAP Power BI SQL SSIS T-SQL UX
Perks/benefits: Career development Flex hours Flexible spending account Flex vacation Health care Insurance Medical leave
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 Lead Data Analyst jobs
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Data Manager jobs
- Open Sr Data Engineer jobs
- Open Power BI Developer jobs
- Open Principal Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Data Scientist II jobs
- Open Product Data Analyst jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Business Data Analyst jobs
- Open Big Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Manager, Data Engineering jobs
- Open Azure Data Engineer jobs
- Open Junior Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Data Product Manager jobs
- Open Principal Data Scientist jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open GCP-related jobs
- Open Data management-related jobs
- Open Java-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open APIs-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open TensorFlow-related jobs
- Open PhD-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open LLMs-related jobs
- Open Airflow-related jobs
- Open Hadoop-related jobs
- Open Data warehouse-related jobs
- Open Databricks-related jobs