Business Intelligence Developer / SSIS SSRS
At a glance
Mid-level Data Analysis & BI role at Collabera. San Diego · full-time · no salary stated · we estimate $107,500–$135,000.
Collabera has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Build data integration and reporting solutions with SSIS, SSRS and T-SQL
- Document the systems, steps and logic that make warehouse data usable for reporting and analysis
- Tune SSIS packages and SSRS reports to improve their performance
- Protect data quality, consistency and security across company data and warehouse systems
- Package code dependencies, manage source control, deploy through continuous integration and use test-driven design in an Agile process
What you bring
- A bachelor's degree in computer science, computer engineering or another listed field
- Three to five years developing with SSIS and SSRS
- Three to five years writing and troubleshooting SQL Server stored procedures
- Three to five years working with OLTP and OLAP databases, plus knowledge of warehouse, BI reporting and database design concepts
Who this fits
This mid-level, hands-on developer role suits someone with several years of SSIS and SSRS development experience. The position is onsite in San Diego.
From the employer
Collabera Inc (Staffing Firm).
We are based out of Morristown, NJ and we have been providing contingent labor to our clients for last 25 years. In 2015 we placed more than 6,000 contractors across select 100+ clients that we service. End client for this project is a large legal organization with operations in more than 100 countries and has more than 50,000 employees around the world. For eight consecutive years, Fortune has named this company as World’s ‘Most Admired Companies to work for’.
Our top direct client is looking for a Business Intelligence Developer.
The client is a Fortune 50 multi-billion dollar revenue generating organization with a spectrum of products and services throughout major operating businesses
Job Responsibilities:
- Responsible for hands on development using SSIS, SSRS and T-SQL.
- Responsible for developing and documenting the systems, processes and logic required to expose the existing data sets in the warehouse to end users for reporting and analysis purposes
- Optimize dtsx packages and rdl reports for performance and improvement opportunities.
- Ensure the quality, consistency and security of company data and data warehouse systems.
- Utilize Source Control, bundle dependencies to make a deliverable unit of code, Build and deploy via a Continuous Integration framework.
- Use a test driven design methodology.
- Participate in an AGILE process.
Required Skills:
- Bachelor’s Degree in Computer Science, Computer Engineering or Information Technology
- Knowledge of Data Warehouse and BI Reporting concepts
- Knowledge of Logical and Physical Database Design
- Knowledge of SSIS and SSRS
- Knowledge of SQL and T-SQL
Required Experience:
- 3-5 years SSIS Development experience
- 3-5 years SSRS Development experience
- 3-5 Experience with writing and debugging SQL Server stored procedures
- 3-5 Experience with Databases – OLTP and OLAP
To set up an Interview, please contact:
Neeraj Mudre
973-854-9114
neeraj.mudre(at)collabera.com
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BI
Find me workBy the team behind dataroles.