Maintain and develop OLAP reporting data schemas and provide support for BI visualizations and ... Understanding of MS SQL Server 2016 security, performance monitoring and optimization techniques
Maintain and develop OLAP reporting data schemas and provide support for BI visualizations and ... Understanding of MS SQL Server 2016 security, performance monitoring and optimization techniques
BI Developer
Boston, MA ยท On-site
BI Developer Location: Boston, MA - once a month initially for 3 months and then remote Duration ... Knowledge of Microsoft SQL Server, SQL Server Reporting Services (SSRS) and SQL Server Integration ...
BI Developer
Boston, MA ยท On-site
BI Developer Location: Boston, MA - once a month initially for 3 months and then remote Duration ... Knowledge of Microsoft SQL Server, SQL Server Reporting Services (SSRS) and SQL Server Integration ...
BI Developer
Boston, MA ยท On-site
BI Developer Duration : Full time Location : Boston, MA Salary : Depands on experience As the BI ... Responsibilities Develop and maintain ETL processes using Microsoft BI Stack (SSAS, SSIS, SSRS ...
BI Developer
Boston, MA ยท On-site
BI Developer Duration : Full time Location : Boston, MA Salary : Depands on experience As the BI ... Responsibilities Develop and maintain ETL processes using Microsoft BI Stack (SSAS, SSIS, SSRS ...
BI Developer
Boston, MA ยท On-site
BI Developer Duration : Full time Location : Boston, MA Salary : Depands on experience As the BI ... Responsibilities Develop and maintain ETL processes using Microsoft BI Stack (SSAS, SSIS, SSRS ...
BI Developer
Boston, MA ยท On-site
BI Developer Duration : Full time Location : Boston, MA Salary : Depands on experience As the BI ... Responsibilities Develop and maintain ETL processes using Microsoft BI Stack (SSAS, SSIS, SSRS ...
BI Developer
Waltham, MA ยท On-site
$100K - $105K/yr
BI Developer Location-Type: Hybrid onsite in Waltham, MA (3 days onsite) Start Date Is: ASAP ... Design, build, and maintain Power BI dashboards using SQL, DAX, and published/certified datasets.
Quick apply
BI Developer
Waltham, MA ยท On-site
$100K - $105K/yr
BI Developer Location-Type: Hybrid onsite in Waltham, MA (3 days onsite) Start Date Is: ASAP ... Design, build, and maintain Power BI dashboards using SQL, DAX, and published/certified datasets.
Power BI Developer
$104K - $142K/yr
Power BI Developer Employment Type: Full-Time, Mid-level Department: Information Technology CGS is ... SSIS experience - SSRS Reporting knowledge Ideally, you will also have: - Experience with ...
Power BI Developer
$104K - $142K/yr
Power BI Developer Employment Type: Full-Time, Mid-level Department: Information Technology CGS is ... SSIS experience - SSRS Reporting knowledge Ideally, you will also have: - Experience with ...
Power BI Developer
Boston, MA ยท On-site
$104K - $142K/yr
Power BI Developer Employment Type: Full-Time, Mid-level Department: Information Technology CGS is ... SSIS experience - SSRS Reporting knowledge Ideally, you will also have: - Experience with ...
Quick apply
Power BI Developer
Boston, MA ยท On-site
$104K - $142K/yr
Power BI Developer Employment Type: Full-Time, Mid-level Department: Information Technology CGS is ... SSIS experience - SSRS Reporting knowledge Ideally, you will also have: - Experience with ...
BI Developer -SSAS / Big Data
Boston, MA ยท On-site
Responsibilities Develop and maintain ETL processes using Microsoft BI Stack (SSAS, SSIS, SSRS ... scope programming efforts and develop time estimates Assessing potential limitations and risks ...
BI Developer -SSAS / Big Data
Boston, MA ยท On-site
Responsibilities Develop and maintain ETL processes using Microsoft BI Stack (SSAS, SSIS, SSRS ... scope programming efforts and develop time estimates Assessing potential limitations and risks ...
BI Developer -SSAS / Big Data
Boston, MA ยท On-site
Responsibilities Develop and maintain ETL processes using Microsoft BI Stack (SSAS, SSIS, SSRS ... scope programming efforts and develop time estimates Assessing potential limitations and risks ...
BI Developer -SSAS / Big Data
Boston, MA ยท On-site
Responsibilities Develop and maintain ETL processes using Microsoft BI Stack (SSAS, SSIS, SSRS ... scope programming efforts and develop time estimates Assessing potential limitations and risks ...
Power BI Developer
Boston, MA ยท On-site
Work with the BI architects on Proofs of concepts and prototypes of new tools, features and ... Intermediate T-SQL Skills
Power BI Developer
Boston, MA ยท On-site
Work with the BI architects on Proofs of concepts and prototypes of new tools, features and ... Intermediate T-SQL Skills
BI Developer with heavy (SSIS, SSRS, SSAS) Duration: 6+ Months Face to Face interview is mandatory ..!!! We need local candidates only ..!!! Important Skills -Must Haves SSRS ETL Kinldy note: This ...
BI Developer with heavy (SSIS, SSRS, SSAS) Duration: 6+ Months Face to Face interview is mandatory ..!!! We need local candidates only ..!!! Important Skills -Must Haves SSRS ETL Kinldy note: This ...
Senior BI Developer
Boston, MA ยท On-site
Position Summary The Senior BI Engineer builds the trusted analytics that power decisions for both ... Strong SQL proficiency. * Fluency working in the AI era: building with coding agents, setting up ...
Quick apply
Senior BI Developer
Boston, MA ยท On-site
Position Summary The Senior BI Engineer builds the trusted analytics that power decisions for both ... Strong SQL proficiency. * Fluency working in the AI era: building with coding agents, setting up ...
Power BI Developer
Boston, MA ยท On-site
Work with the BI architects on Proofs of concepts and prototypes of new tools, features and ... Intermediate T-SQL Skills #J-18808-Ljbffr
Power BI Developer
Boston, MA ยท On-site
Work with the BI architects on Proofs of concepts and prototypes of new tools, features and ... Intermediate T-SQL Skills #J-18808-Ljbffr
Power BI Developer with Security Clearance
Boston, MA ยท On-site
$104K - $142K/yr
Power BI Developer Employment Type: Full-Time, Mid-level Department: Information Technology CGS is ... SSIS experience - SSRS Reporting knowledge Ideally, you will also have: - Experience with ...
Power BI Developer with Security Clearance
Boston, MA ยท On-site
$104K - $142K/yr
Power BI Developer Employment Type: Full-Time, Mid-level Department: Information Technology CGS is ... SSIS experience - SSRS Reporting knowledge Ideally, you will also have: - Experience with ...
Senior Developer, BI Reporting
Boston, MA ยท Hybrid
... BI, SQL Server, Data Warehouse and upcoming BI technologies. This role requires specialized ... Advanced MS Office skills - especially Excel, including macro development and troubleshooting.
Senior Developer, BI Reporting
Boston, MA ยท Hybrid
... BI, SQL Server, Data Warehouse and upcoming BI technologies. This role requires specialized ... Advanced MS Office skills - especially Excel, including macro development and troubleshooting.
Senior Developer, BI Reporting
Boston, MA ยท On-site
... BI, SQL Server, Data Warehouse and upcoming BI technologies. This role requires specialized ... Advanced MS Office skills - especially Excel, including macro development and troubleshooting.
Senior Developer, BI Reporting
Boston, MA ยท On-site
... BI, SQL Server, Data Warehouse and upcoming BI technologies. This role requires specialized ... Advanced MS Office skills - especially Excel, including macro development and troubleshooting.
We are currently seeking a Tableau Developer (SAP Financial data BI) to join one of our clients ... Experience with data modeling, ETL processes, and SQL queries. * Ability to translate business ...
We are currently seeking a Tableau Developer (SAP Financial data BI) to join one of our clients ... Experience with data modeling, ETL processes, and SQL queries. * Ability to translate business ...
Redshift Developer
Burlington, MA ยท On-site
... engineers, BI engineers REQUIRED SKILLS: * 10+ years' experience in DW architecture and DW ... Oracle, MS SQL Server) * Experience with major analytics software * Presentation skills; high ...
Redshift Developer
Burlington, MA ยท On-site
... engineers, BI engineers REQUIRED SKILLS: * 10+ years' experience in DW architecture and DW ... Oracle, MS SQL Server) * Experience with major analytics software * Presentation skills; high ...
BI Engineer - North Reading, Ma/quicksuite/sql
North Reading, MA ยท On-site
$52.25 - $67.75/hr
... Intelligence (BI) Engineer. In this capacity, you will be instrumental in crafting adaptive ... Extensive command of SQL for manipulating, extracting, and analyzing data * Hands-on experience ...
BI Engineer - North Reading, Ma/quicksuite/sql
North Reading, MA ยท On-site
$52.25 - $67.75/hr
... Intelligence (BI) Engineer. In this capacity, you will be instrumental in crafting adaptive ... Extensive command of SQL for manipulating, extracting, and analyzing data * Hands-on experience ...
BI Engineer - North Reading, Ma/quicksuite/sql
North Reading, MA ยท On-site
$52.25 - $67.75/hr
... Intelligence (BI) Engineer. In this capacity, you will be instrumental in crafting adaptive ... Extensive command of SQL for manipulating, extracting, and analyzing data * Hands-on experience ...
BI Engineer - North Reading, Ma/quicksuite/sql
North Reading, MA ยท On-site
$52.25 - $67.75/hr
... Intelligence (BI) Engineer. In this capacity, you will be instrumental in crafting adaptive ... Extensive command of SQL for manipulating, extracting, and analyzing data * Hands-on experience ...
Ms Sql Bi Developer information
See Boston, MA salary details
$83.1K - $90.4K
3% of jobs
$90.4K - $97.7K
12% of jobs
$103.4K is the 25th percentile. Wages below this are outliers.
$97.7K - $105K
13% of jobs
$105K - $112.3K
13% of jobs
The median wage is $115.6K / yr.
$112.3K - $119.7K
20% of jobs
$119.7K - $127K
9% of jobs
$131.3K is the 75th percentile. Wages above this are outliers.
$127K - $134.3K
9% of jobs
$134.3K - $141.6K
13% of jobs
$141.6K - $148.9K
8% of jobs
$148.9K - $156.2K
1% of jobs
$156.2K - $163.5K
0% of jobs
$83.1K
$120.9K
$163.5K
How much do ms sql bi developer jobs pay per year?

SQL Database and Business Intelligence Developer II
Boston, MA โข On-site
Full-time
Re-posted 29 days ago
Job description
Job Title: ย ย ย ย SQL Database and Business Intelligence Developer II
Department: Information Technology
Reports To:ย ย Senior SQL Database and Business Intelligence Developer
FLSA:ย ย ย ย ย ย Exempt
Status: ย ย ย ย ย ย ย ย ย ย Full-Time
Grade: ย ย ย ย ย ย ย ย ย ย 12
POSITION DESCRIPTION AND SCOPE
The SQL Database and Business Intelligence Developer II is responsible for the development, testing, implementation and support of Microsoft SQL-based relational databases. The databases are used to collect and analyze data gathered through the Authority's custom web applications that are both internal and client-facing.ย This position is also responsible for developing and supporting data sets and visualizations utilizing various business intelligence and reporting platforms. ย This position will ensure the database is well maintained, scalable and available to all users. This position will also administer the database systems through security, backup and recovery, tuning, automation and disaster recovery planning and testing for MSBA database environments. Working with the IT team, the SQL Database and Business Intelligence Developer II will participate in the full development life cycle to meet the objectives of the MSBA.
- Design, develop, test, and implement changes and enhancements to SQL Databases as required
- Maintain and develop OLAP reporting data schemas and provide support for BI visualizations and dashboards as assigned, using various BI reporting platforms including, but not limited to, Tableau and Power BI
- Develop an understanding of MSBA business processes and workflows to align database architecture with such processes and workflows.
- Maintain and implement database objects, including tables, views, keys, indexes, constraints, defined types, functions, stored procedures, etc.
- Code stored procedures of high complexity to meet product requirements
- Work to implement and maintain SSRS reports ensuring they are of the highest data and visual quality
- Support business and client users of the web application through "back-end" database problem solving and troubleshooting of various issues as they arise
- Maintain and manage database schemas, SQL agent jobs and user's roles with proper permissions.
- Troubleshoot database performance issues to ensure optimizations in system designs.
- Manage code migration to various environments according to software development life cycle.
- Maintain and write comprehensive documentation, including database dependencies, database inventory, basic database troubleshooting, and daily database operations documents.
- Support the operational strategies and priorities of the Authority.
- Able to independently work with internal stakeholders to identify, gather business requirements, propose analytical report solutions and implement the proposed solutions.
- Troubleshoot and resolve outages from existing applications.
- Maintain quality service through IT policies and standards.
- Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; benchmarking state-of-the-art practices; participating in professional societies.
- Perform other duties as assigned
- Four-year degree in technical discipline and 5+ years of relevant professional experience in SQL database development and BI reporting
- Strong SQL Server 2016(and above) and BI reporting tools such as Tableau and Power BI in a large-scale production environment
- Highly experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
- Strong knowledge of relational and dimensional data modeling
- Highly experienced in writing and optimizing database scripts, SQL stored procedures, functions and other SQL database objects that assist in the implementation and maintenance of business logic and data flows through MSBA data and application infrastructure.
- Experience analyzing and driving reporting requirements to design and implement complex static and dynamic BI reporting and ad-hoc query reports.
- Experience in code migration, database change management and data management through the various stages of the development lifecycle
- Thorough understanding with hands-on skills of MS SQL Server 2016 (and above) and SSRS Server installation and configurations. Understanding of MS SQL Server 2016 security, performance monitoring and optimization techniques
- Work with our team members and in-house QA to resolve bugs and issues.
- Follow proper application, operations, standards, policies and procedures. Ensure that the integrity and consistency of company databases is maintained
- Experience with versioning control environments including Azure DevOps and/or GIT
- Strong communication skills and the ability to work both independently and as part of a team
- Excellent analytical, technical, problem solving and project management skills with ability to coordinate complex projects with competing priorities and deadlines
- Professional interpersonal style; ability to work and build trust with a diverse range of people
- Ability to work in an Agile environment.
- Ability to work creatively, learn quickly and solve complex problems in high-pressure situations
- Exhibit a professional 'can-do' attitude and flexible work style approach
- Ability and willingness to proactively research and/or resolve issues
- Relevant Microsoft Certifications
- Masters in technical discipline
- Experience in Database Design and administration.
- Experience with cloud-based solutions
- Experience with VB.Net, ASP.Net and C#
- Experience with network/storage architecture
About Massachusetts School Building Authority
Sourced by ZipRecruiter
Industry
Construction
Company size
51 - 200 Employees
Headquarters location
Boston, MA, US
Year founded
2004