Designs and develops SQL Server databases, including tables, views, procedures, functions, triggers, constraints, and secure code. Creates SSRS reports, SSIS packages, SSAS cubes, and data warehouses. Supports application development, database migrations, performance and concurrency issues, and backend requirements gathering.
Company Description
Boston Technology Corporation (BTC), based in Marlborough, MA, is a leading Enterprise Mobility and Software services provider. Our clients range from Fortune 500 companies to innovative startups. From cutting edge enterprise mobility solutions to robust web applications, we have enabled them to leverage the power of technology.
- Create Entity Relationship (ER) Diagrams to the proposed database
- Create database objects such as tables, views, stored procedures, Triggers etc.
- Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
- Identify columns for Primary Keys in all the tables at the design time and create them.
- Create functions to provide custom functionality as per the requirements.
- Be aware of potential blocking, deadlocking and write code to avoid those situations.
- Endure that the code is written keeping in mind any security issues such as SQL Injection.
- Develop reports in SQL Server Reporting Services.
- Design, Develop and Deploy SSIS Packages.
- Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
- participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
- Participate in development and creation of Data warehouses.
- Create cubes in SQL Server Analysis Services.
All your information will be kept confidential according to EEO guidelines.
Boston Technology Corporation Boston, Massachusetts, USA Office
Boston, United States
Similar Jobs
Cloud • Information Technology • Consulting
Develops technical solutions, coordinates technical assignments, creates coding flowcharts, performs programming, analyzes data flows, conducts gap analysis and business mapping, and works with Oracle technologies. Requires frequent travel to client sites throughout the United States, including unanticipated long- and short-term assignments.
Top Skills:
OracleSql DeveloperToad
Fintech • Software • Financial Services
Leads the architecture, development, deployment, and optimization of Workday integrations across HR, finance, and enterprise systems. Designs scalable solutions using Workday tools, APIs, middleware, web services, XML/XSLT, and SQL. Partners with business and technical stakeholders, oversees integration projects, mentors team members, troubleshoots issues, documents solutions, and ensures testing, release, compliance, and data accuracy across systems.
Top Skills:
.NetApi ManagementJavaJitterbitMulesoftRestSoapSQLSql DeveloperWorkday Core ConnectorsWorkday EibWorkday StudioXMLXslt
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
The Senior Data Analyst gathers BI requirements, analyzes enterprise and offline datasets, writes and optimizes SQL queries, and builds dashboards using Power BI, Tableau, and Domo. The role translates business needs into technical specifications, designs dashboard wireframes, validates data, documents processes, and collaborates with engineering, product, and business teams. Knowledge of the US trust business is essential for interpreting data within financial and regulatory contexts.
Top Skills:
DomoPower BISQLSql DeveloperTableau
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
