SYSCOM, Inc. is seeking a Business Intelligence Developer to support their client's Business Intelligence and Data Warehouse Project needs as part of a Digital Transformation initiative. The goal is to build better products with faster and better data and business insights.
Requirements
- At least 1 year of hands-on experience in using Generative AI to successfully deliver data analytics solutions.
- At least 5 years of hands-on experience of designing and developing data analytics, and Business Intelligence dashboards with Microsoft (MS) Power BI.
- At least 5 years of experience of creating Structural Query Language (SQL) queries, optimizing SQL query performance, and modifying SQL elements such as procedure, functions, and views with a solid understanding of database principles.
- At least 3 years of experience of developing data solutions with Snowflake or Amazon Web Services (AWS) Redshift data warehouses.
- At least five years of experience with MS Power BI Data Analysis Expressions (DAX) to create queries, measures, and data models.
- Ability to use business knowledge and expertise to build analytical data models and reports that can serve business users.
Responsibilities
- Work with data architects, business analysts, Extract Transformation Load (ETL) developers, and business stakeholders to design, develop, and deliver high standard Business Intelligence (BI) solutions. This can include, but is not limited to, enterprise analytical reports, dashboards, data warehouse, data lake, data marts, and ETL processes.
- Integrate Generative AI capabilities with BI&DW platform to automatically generate business insights and recommendations, reducing the need for manual data analysis and interpretation, leading to faster decision-making.
- Leverage machine learning and artificial intelligence to provide predictive business insights to anticipate future trends and opportunities.
- Analyze product performance, identify key metrics, and build analytical reports and dashboards to meet business needs, implement the high priority initiatives, and instill discipline and accountability into the product development process.
- Lead and conduct functional testing of the Business Intelligence solutions, thereby responsible for certification of product release before user acceptance. Encourage best practices and apply them in the team - responsible for functional product quality.
- Build queries and large quantities of data by using Structural Query Language (SQL), or other data and statistical tools as well as reporting tools such as Tableau, Power BI, or Looker, etc.
- Execute deep dives into available data sets to provide insight on product quality performance and ensure a good user experience in support reports and dashboards.
Other
- Work Location: Hybrid model with 2–3 days per week on-site in West Sacramento, CA, and 2–3 days remote.
- Ability to work a hybrid schedule which requires being on-site 2-3 days per week in West Sacramento, CA.
- At least five years of experience with Agile methodologies and Software Development Life Cycle.
- At least 3 years of experience in State agency or Financials or Investment portfolios or other regulated industry highly preferred.
- Bachelor’s degree or equivalent experience in Computer Science, Information Technology, or similar field of study.
