Dice | Hiring | SQL, Senior BI Developer, ETL | Irvine, CA | BigDataKB.com | 2022-09-27

0

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

Apply Here

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 📝💼

LEAVE A REPLY

Please enter your comment!
Please enter your name here