Job Description

Key Info:

• We are looking for a BI Developer who is really strong in Power BI development, you will be maintaining, troubleshooting the current Power BI dashboards but will also be creating new dashboards and reports 
• Strong in creating SSIS packages for ETL processes 
• Strong with data, able to pull data from different ERP sources (company is using MS Dynamic GP)
• Will be troubleshooting and supporting the current data warehouse, might be creating new ones in the future 
• Strong MS SQL development experience in creating queries, stored procedures, SQL jobs management, and just making sure everything is running within the system 

Responsibilities:

• Manage ETL (Extract, Transform, Load) functions Perform complex queries using SQL and / or other tools (e.g., R, Python Pandas, PySpark)
• Develop, build, test, and maintain scalable data pipeline architectures and tools
• Develop SSIS processes that extract data from CoolSys systems (both internal and external) to post into our data warehouse infrastructure
• Performs routine application monitoring and maintenance of these processes
• Works closely with the business teams to refine business requirements documents
• Assist the business teams with quality assurance and testing of data processes
• Assist with creation of ETL process documentation of interfaces used between critical systems
• Help create and test SQL statements for data presentation and further automation
• Assist with other duties as assigned

Requirements:

• Experience working with SQL Server,SQL scripts and SSIS packages, with the ability to detect and correct problems within SQL scripts
• Familiarity with cloud-based services (AWS, Azure, GCP)
• Experience managing Power BI
• Experience in data warehousing projects, data preparation, and data gateways
• Experience with Business Intelligence analytical tools such as SSRS, SSAS, SSIS
• Knowledge of JavaScript and SQL
• Excellent attention to detail and strong time management skills
• Excellent communication skill is a must
• Understanding of relational database model principles
• Understanding of Extract, Transform & Load (ETL) data integration principles
• Understanding of agile methodology as it relates to the software development lifecycle
• Ability to work independently or in a collaborative team
• Supporting users/customers: identifying and addressing needs, building relationships, being flexible, communicating effectively
• Experience with JIRA project management software
• Bachelor's degree in Computer Science or equivalent

We are an equal opportunity employer and make hiring decisions based on merit. Recruitment, hiring, training, and job assignments are made without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, or any other protected classification. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.
To apply please email your resume to ywest@ledgent.com

Job Snapshot

• Employee Type:Full-Time
• Location:Tustin, CA
• Job Type:I.T.
• Experience:Not Specified
• Education:Not Specified
• Date Posted:5/30/2023
• Contact: Blair West (714) 940-5420
• Pay Range: $120,000.00 - $135,000.00 Annually

Get Job Alertsby Email

• Receive alerts with new job opportunities that match your interests
• Receive relevant communications and updates from our organization

Sign Up Now