Software Management Consultants, Inc.

Developer - SQL Server, Power BI, SQL

  • Job Type: Full Time
  • Industry Type: IT Sector
  • Industry Location: El Monte
  • Experience: NA
  • No. of Positions: 1
  • Primary Skills: SQL Server Power BI
  • Secondary Skills: SQL
  • Job Location: El Monte, California
  • Posted Date: Posted today
Job Description

Job Description:

Seeking a Senior Business Intelligence Developer to work closely with internal customers and BI Analysts to turn data into critical information and knowledge that can be used to make sound business decisions. The right candidate will need to identify business needs and build solutions to drive business growth, automation and enablement for multiple business partners such as Retail Banking, Digital Banking, Compliance, Financial Planning and Analysis, Operations, and more. This role requires a strong knowledge of BI solutions, data analytics, data management and normalization, data modeling & visualization tools. This position will be responsible for unlocking, designing and implementing data solutions for business partners, utilizing data, data science and tech solutions to drive insights and ultimately value for the company. This individual must function in a fast-paced environment, be adaptable to the many changing processes and technology related to the various data warehouse environments.


  • Work closely with BI team, data engineers, DBA groups, and business partners to create technical requirements, database design and BI solutions that will empower business partners to embrace data confidently and responsibly to address their complex challenges
  • Power BI and SSRS administration for on premises and Reporting Services
  • Build enterprise scalable, complex data visualizations, dashboards, KPI scorecards, and KRI reports, etc. in Power BI Desktop
  • Proficient in DAX and M queries
  • Leverage knowledge of data modeling methodologies and other data warehousing activities to translate data into actionable analytical solutions and promote information-based decision-making recommendations.
  • Using past experiences, make recommendations on Enterprise BI standards/best practices
  • Performance tuning and query optimization
  • Provide guidance to other BI developers with oversight from the BI Managers and Leads
  • Implement statistical or other mathematical methodologies as needed for specific models or analysis
  • Keep up-to-date with latest technology trends

  • 7+ years practical experience with business intelligence solution including building/supporting data-intensive systems, data warehouses and data marts with clear understanding of industry standard concepts (star schema, snowflake, ER)
  • 2+ years hands on experience in Data Visualization or advance analytics using Power BI
  • Expertise in SQL, ELT/ETL, reporting and Visual Analytics tools including SSMS, SSRS, SSIS and Power BI, with proven implementation and adoption in a large-scale enterprise environments
  • Solid T-SQL knowledge and SQL query development using MS SQL 2016 or later
  • Proficiency in data analysis, data profiling, data mining, data extraction, and data enrichment
  • MS in Computer Science, Information Systems, Data Science or equivalent combination of skills, experience and education
  • Experience in banking or financial services
  • Creative problem solver who thrives when presented with a challenge
  • Excellent attention to detail
  • Comfortable in both a leadership and team-player role
  • Able to multitask, prioritize, and manage time effectively
  • Excellent communication, interpersonal and organizational skills

  • Software languages - C#, PowerShell, Python, .NET
  • Experience in Cloud Data Warehouse technologies such as Azure Data Warehouse, AWS RedShift, Snowflake.
  • Experience with relational databases (SQL/PLSQL/Hive) and leveraging large data sets within a data warehouse (Hadoop, Oracle, MySQL)
  • Experience with DevOps, Continuous Integration and Continuous Delivery (Maven, Jenkins, Stash, Ansible, Docker) is a plus
  • Understanding of Machine Learning
  • Understanding of Adobe Analytics and Omniture, Google Analytics, and other Social/App Tracking Tools
  • Understanding of analytical methods and regression models, and advanced analytics software (SAS, R, Python and others), big data programming
  • Have solid / emerging experience with statistical modeling, analytics, database usage and design theories

    Don't hesitate! Submit your resume today.

    SMCI is an EEO employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, national origin, disability, age, genetic information, marital status, military, and veteran status. Members of minority groups, Vietnam Era Veterans and individuals with mental or physical disabilities are encouraged to contact us regarding employment opportunities. In addition, in order to support the provision of business to minority-owned and Women-owned businesses (MWBE), such MWBE are encouraged to contact us regarding subcontracting business opportunities with our firm.

    (No third parties, please)
    (H1 sponsorship currently unavailable)
    (Local candidates only, please)
Relevant Job Openings
Oracle Developer
Tableau developer
Java Developer
Azure Data Architect with Talend
Azure Cloud Architect
Java Full stack Developer