Job Location: Irvine, CA
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Macgain, is seeking the following. Apply via Dice today!
Requirements:
- Min 10+ years extensive hands-on experience in developing ETL Workflows, Data Models, Charts, Graphs using Power BI (including team lead role)
- Experience in development, administration and utilizing tools from MS SQL Server BI Stack which includes SSIS, SSAS, SSRS, T-SQL, Power Pivot, Power BI, MDX and DAX
- Experience in designing and developing ETL Mappings and ETL Jobs/Workflows
- Expertise on data warehouse design – dimensional modeling and data mining
- In-depth knowledge of DMBS concepts, relational database design, multidimensional database design, OLTP and OLAP, other ETL processes
- Strong experience on SQL – in writing queries including joins, sub-queries, inline queries, views, etc.
- Experience in writing T-SQL Queries and Stored Procedures
- Experience with SQL Server Reporting Services, SQL Server Analysis Services and Transparent Data Encryption (TDE)
- Design and develop Power BI Dashboards, Dataflows/Datasets
- Experience in extracting data and creating paginated reports using SSRS or dashboards using Power BI (dataflows and/or datasets)
- Good understating of MDX and DAX, data modeling in Power BI
- Prepare technical specifications and documentation for workflows supporting BI reports, write test cases for data comparison between report and SQL backend, performance tuning
- Ability to debug data issues by writing free-hand SQL queries and comparing the same with report / dashboard data.
- Experience working using Agile Methodology and very good communication skills.
Nice to Have
- Experience on Aerospace domain will be an added benefit
- Experience with Big Data Technologies like Azure Data Lake, NoSQL Database
- Familiar with data masking tools and capabilities
- Metadata management and data integrity skills
Roles
- Work closely with Business SME’s, Client IT Team and End Users to translate stakeholders’ requirements into reporting deliverable and workflows
- Gather, analyze & document business requirements in BI context and design data models to transform raw data into meaningful insights
- Work alongside other ETL and report developers and architects to develop cohesive BI solutions
- Collaborate with multiple teams / SMEs to develop and configure BI solutions and integrate systems
- Provide effort estimation for development activities after analyzing current ETL process, business requirements
- Redefine and make technical/strategic changes to enhance/improvise existing Business Intelligence solutions
- Design, develop & schedule Power BI Dashboards, SSRS Reports and ETL workflows (Business Intelligence solutions)
- Development, deployment and administration activities on Power BI and SQL/SSRS Components.
- Strong analytical, problem solving, and troubleshooting abilities
- Write and review technical documentation in support of BI solutions being developed
- Able to diagnose report issues and performance tune reports and workflows
- Ensure compliance to applicable standards, policies, procedures, and best practices during development and maintenance activities
- Participate in daily/weekly meetings and provide timely scheduled management reporting
- Ready to learn and explore different tools like Alteryx.
- provided by Dice
Submit CV To All Data Science Job Consultants Across United States For Free
🔍 Explore All Related ITSM Jobs Below! 🚀
✅ Select your preferred "Job Category" in the Job Category Filter 🎯
🔎 Hit "Search" to find matching jobs 🔥
➕ Click the "+" icon that appears just before the company name to see the Job Detail & Apply Link 📝💼

